import pandas as pd
from sqlalchemy import create_engine
import time

conn = create_engine("mysql+mysqldb://root:123456@localhost:3306/study?charset=utf8")

df = pd.read_excel('1810.xls')

df.to_sql("s_info",conn,if_exists='replace',index=False)